| |
|
Detection of Insurance Fraud
Minár, Tomáš ; Šrajer, Petr (referee) ; Kříž, Jiří (advisor)
This thesis focuses on the area of detection of potential insurance frauds by using Business Intelligence (BI) and its practical application to real data of compulsory and accident insurance. It describes the basic concepts of insurance business, the individual layers of BI architecture, and a detailed description of the implementation process from data transformation through the use of advanced analytical methods to the presentation of acquired information.
|
| |
|
Monitoring and Profiling Solution for the BI System
Veselovský, Matej ; Bednář, Luboš (referee) ; Kříž, Jiří (advisor)
This master’s thesis focuses on monitoring and profiling multidimensional database and reports. The project was created in MS SSIS to this purpose and it contains 4 ETL packages. The thesis is divided into three main sections. First section consists of theoretical background needed to accomplish the goal. In second section there is analysis of the company for which is the solution created and in the third part of the thesis there is described the proposal and it’s solution. Proposal of the solution and the solution itself was created in MS Visual Studio 2015, MS SQL Management Studio and Power BI.
|
|
Application for Displaying OLAP Data Cubes
Kiss, Tomáš ; Burget, Radek (referee) ; Bartík, Vladimír (advisor)
The main aim of this thesis is to provide information about the basic issues of data warehouses, data cubes and OLAP analysis. Furthermore, in the theoretical part is introduced the stage of data preprocessing and its elementary parts performed before their insertion in to data warehouses. Additionally, there are listed the basic types of OLAP operations and the possible ways of displaying data cubes. Acquired information is used to create application for displaying OLAP data cubes in suitable format.
|
|
Global Meteorological Data Analysis
Gerych, Petr ; Chmelař, Petr (referee) ; Hlosta, Martin (advisor)
The thesis generally describes matters of data warehouses and knowledge discovery in databases. Then it focuses on the meteorological databases and their problems. The practical part of thesis describes design methods for data mining project, NOAA Global Surface Summary of the Day (GSOD), which is then implemented in two different ways using the Pentaho tools. Finally, an evaluation and comparison of these two approaches.
|
| |
|
Business Intelligence Solutions
Dzimko, Miroslav ; Achimský,, Karol (referee) ; Kříž, Jiří (advisor)
Diploma thesis presents an evaluation of the current state of the company system, identification of critical areas and areas suitable for improvement. Based on the theoretical knowledge and analysis results, commercial Business Intelligence software is designed to enhance the quality and efficiency of the company's decision-support system and the introduction of an advanced Quality Culture system. The thesis reveals critical locations in the corporate environment and opens up space to design improvements to the system.
|
|
ALVAO Service Desk Data Analysis and Reporting
Václavík, Marek ; Novák, Lukáš (referee) ; Kříž, Jiří (advisor)
The diploma thesis focuses on the analysis of the current state of reporting and data analysis of the ALVAO Service Desk system in the company's internal operation. Based on the findings of deficiencies, a new method of reporting and data analysis on the Microsoft Power BI platform is proposed. The proposal includes the entire Power BI feature cycle from data accessing to sharing.
|
|
Client for Displaying OLAP Cubes
Podsedník, Lukáš ; Kupčík, Jan (referee) ; Bartík, Vladimír (advisor)
At the beginning, the project describes basics and utilization of data warehousing and OLAP techniques and operations used within the data warehouses. Then follows a description of one of the commercial OLAP client - based on the features of this product the requirement analysis of the freeware OLAP cube client displayer is desribed - choosing the functionality to be implemented in the client. Using the requirement analysis the structural design of the application (including UML diagrams) is made. The best solution from compared libraries, frameworks and development environments is chosen for the design. Next chapter is about implementation and tools and frameworks used in implemetation. At the end the thesis clasifies the reached results and options for further improvement.
|